KinnShare: Find Near MRT-Queen Sirikit National Convention Centre

This is the test environment server: dev.kinnshare.com

Banner 728x90

English

ภาษาไทย

Near where

Wanna Eat/Find

No results found for your search.

Add new restaurant you know.

Don't find it?

Add new restaurant you know.

Loading map...

Zoom map with mouse scroll wheel

Site map

About us

Help

KinnShare.com เป็น ภาษาไทย

(default) 27 queries took 228 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SHOW FULL COLUMNS FROM `rests_pics`	22	22	20
2	SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';	1	1	2
3	SHOW FULL COLUMNS FROM `rest_pic_types`	6	6	21
4	SHOW FULL COLUMNS FROM `rest_chains_rest_types`	3	3	15
5	SHOW FULL COLUMNS FROM `rest_types`	10	10	18
6	SHOW FULL COLUMNS FROM `rests_rest_types`	3	3	11
7	SHOW FULL COLUMNS FROM `rest_chains_rest_features`	3	3	16
8	SHOW FULL COLUMNS FROM `rest_features`	10	10	20
9	SHOW FULL COLUMNS FROM `rests_rest_features`	3	3	10
10	SHOW FULL COLUMNS FROM `rest_chains_histories`	18	18	18
11	SHOW FULL COLUMNS FROM `website_deals`	17	17	11
12	SHOW FULL COLUMNS FROM `articles`	14	14	16
13	SHOW FULL COLUMNS FROM `articles_pics`	6	6	11
14	SHOW FULL COLUMNS FROM `articles_comments`	8	8	11
15	SHOW FULL COLUMNS FROM `articles_blds`	5	5	11
16	SHOW FULL COLUMNS FROM `articles_rests`	5	5	11
17	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1	2	2	0
18	SELECT `Mrt`.`id`, `Mrt`.`line`, `Mrt`.`station_no`, `Mrt`.`station_code`, `Mrt`.`nameTh`, `Mrt`.`nameEn`, `Mrt`.`addr`, `Mrt`.`lat`, `Mrt`.`lng`, `Mrt`.`num_rests`, `Mrt`.`num_blds`, `Mrt`.`exit1_lat`, `Mrt`.`exit1_long`, `Mrt`.`exit2_lat`, `Mrt`.`exit2_long`, `Mrt`.`exit3_lat`, `Mrt`.`exit3_long`, `Mrt`.`exit4_lat`, `Mrt`.`exit4_long`, `Mrt`.`exit5_lat`, `Mrt`.`exit5_long`, `Mrt`.`exit6_lat`, `Mrt`.`exit6_long`, `Mrt`.`created`, `Mrt`.`modified`, `Mrt`.`nearby_bts1_id`, `Mrt`.`nearby_bts2_id`, `Mrt`.`nearby_bts3_id`, `Mrt`.`nearby_mrt1_id`, `Mrt`.`nearby_mrt2_id`, `Mrt`.`nearby_mrt3_id`, `Mrt`.`popular_ranking`, (CONCAT("MRT-", `Mrt`.`nameTh`)) AS `Mrt__full_nameTh`, (CONCAT("MRT-", `Mrt`.`nameEn`)) AS `Mrt__full_nameEn` FROM `mrts` AS `Mrt` WHERE ((`Mrt`.`nameEn` LIKE '%Queen Sirikit National Convention Centre%') OR (`Mrt`.`nameTh` LIKE '%Queen Sirikit National Convention Centre%')) LIMIT 1	1	1	1
19	SELECT `Mrt`.`id`, `Mrt`.`line`, `Mrt`.`station_no`, `Mrt`.`station_code`, `Mrt`.`nameTh`, `Mrt`.`nameEn`, `Mrt`.`addr`, `Mrt`.`lat`, `Mrt`.`lng`, `Mrt`.`num_rests`, `Mrt`.`num_blds`, `Mrt`.`exit1_lat`, `Mrt`.`exit1_long`, `Mrt`.`exit2_lat`, `Mrt`.`exit2_long`, `Mrt`.`exit3_lat`, `Mrt`.`exit3_long`, `Mrt`.`exit4_lat`, `Mrt`.`exit4_long`, `Mrt`.`exit5_lat`, `Mrt`.`exit5_long`, `Mrt`.`exit6_lat`, `Mrt`.`exit6_long`, `Mrt`.`created`, `Mrt`.`modified`, `Mrt`.`nearby_bts1_id`, `Mrt`.`nearby_bts2_id`, `Mrt`.`nearby_bts3_id`, `Mrt`.`nearby_mrt1_id`, `Mrt`.`nearby_mrt2_id`, `Mrt`.`nearby_mrt3_id`, `Mrt`.`popular_ranking`, (CONCAT("MRT-", `Mrt`.`nameTh`)) AS `Mrt__full_nameTh`, (CONCAT("MRT-", `Mrt`.`nameEn`)) AS `Mrt__full_nameEn`, `NearbyToBts1`.`id`, `NearbyToBts1`.`isBtsOrMrt`, `NearbyToBts1`.`line`, `NearbyToBts1`.`station_no`, `NearbyToBts1`.`station_code`, `NearbyToBts1`.`nameTh`, `NearbyToBts1`.`nameEn`, `NearbyToBts1`.`addr`, `NearbyToBts1`.`lat`, `NearbyToBts1`.`lng`, `NearbyToBts1`.`num_rests`, `NearbyToBts1`.`num_blds`, `NearbyToBts1`.`exit1_lat`, `NearbyToBts1`.`exit1_long`, `NearbyToBts1`.`exit2_lat`, `NearbyToBts1`.`exit2_long`, `NearbyToBts1`.`exit3_lat`, `NearbyToBts1`.`exit3_long`, `NearbyToBts1`.`exit4_lat`, `NearbyToBts1`.`exit4_long`, `NearbyToBts1`.`exit5_lat`, `NearbyToBts1`.`exit5_long`, `NearbyToBts1`.`exit6_lat`, `NearbyToBts1`.`exit6_long`, `NearbyToBts1`.`created`, `NearbyToBts1`.`modified`, `NearbyToBts1`.`nearby_bts1_id`, `NearbyToBts1`.`nearby_bts2_id`, `NearbyToBts1`.`nearby_bts3_id`, `NearbyToBts1`.`nearby_mrt1_id`, `NearbyToBts1`.`nearby_mrt2_id`, `NearbyToBts1`.`nearby_mrt3_id`, `NearbyToBts1`.`popular_ranking`, (CONCAT("BTS-", `NearbyToBts1`.`nameTh`)) AS `NearbyToBts1__full_nameTh`, (CONCAT("BTS-", `NearbyToBts1`.`nameEn`)) AS `NearbyToBts1__full_nameEn`, `NearbyToBts2`.`id`, `NearbyToBts2`.`isBtsOrMrt`, `NearbyToBts2`.`line`, `NearbyToBts2`.`station_no`, `NearbyToBts2`.`station_code`, `NearbyToBts2`.`nameTh`, `NearbyToBts2`.`nameEn`, `NearbyToBts2`.`addr`, `NearbyToBts2`.`lat`, `NearbyToBts2`.`lng`, `NearbyToBts2`.`num_rests`, `NearbyToBts2`.`num_blds`, `NearbyToBts2`.`exit1_lat`, `NearbyToBts2`.`exit1_long`, `NearbyToBts2`.`exit2_lat`, `NearbyToBts2`.`exit2_long`, `NearbyToBts2`.`exit3_lat`, `NearbyToBts2`.`exit3_long`, `NearbyToBts2`.`exit4_lat`, `NearbyToBts2`.`exit4_long`, `NearbyToBts2`.`exit5_lat`, `NearbyToBts2`.`exit5_long`, `NearbyToBts2`.`exit6_lat`, `NearbyToBts2`.`exit6_long`, `NearbyToBts2`.`created`, `NearbyToBts2`.`modified`, `NearbyToBts2`.`nearby_bts1_id`, `NearbyToBts2`.`nearby_bts2_id`, `NearbyToBts2`.`nearby_bts3_id`, `NearbyToBts2`.`nearby_mrt1_id`, `NearbyToBts2`.`nearby_mrt2_id`, `NearbyToBts2`.`nearby_mrt3_id`, `NearbyToBts2`.`popular_ranking`, (CONCAT("BTS-", `NearbyToBts2`.`nameTh`)) AS `NearbyToBts2__full_nameTh`, (CONCAT("BTS-", `NearbyToBts2`.`nameEn`)) AS `NearbyToBts2__full_nameEn`, `NearbyToBts3`.`id`, `NearbyToBts3`.`isBtsOrMrt`, `NearbyToBts3`.`line`, `NearbyToBts3`.`station_no`, `NearbyToBts3`.`station_code`, `NearbyToBts3`.`nameTh`, `NearbyToBts3`.`nameEn`, `NearbyToBts3`.`addr`, `NearbyToBts3`.`lat`, `NearbyToBts3`.`lng`, `NearbyToBts3`.`num_rests`, `NearbyToBts3`.`num_blds`, `NearbyToBts3`.`exit1_lat`, `NearbyToBts3`.`exit1_long`, `NearbyToBts3`.`exit2_lat`, `NearbyToBts3`.`exit2_long`, `NearbyToBts3`.`exit3_lat`, `NearbyToBts3`.`exit3_long`, `NearbyToBts3`.`exit4_lat`, `NearbyToBts3`.`exit4_long`, `NearbyToBts3`.`exit5_lat`, `NearbyToBts3`.`exit5_long`, `NearbyToBts3`.`exit6_lat`, `NearbyToBts3`.`exit6_long`, `NearbyToBts3`.`created`, `NearbyToBts3`.`modified`, `NearbyToBts3`.`nearby_bts1_id`, `NearbyToBts3`.`nearby_bts2_id`, `NearbyToBts3`.`nearby_bts3_id`, `NearbyToBts3`.`nearby_mrt1_id`, `NearbyToBts3`.`nearby_mrt2_id`, `NearbyToBts3`.`nearby_mrt3_id`, `NearbyToBts3`.`popular_ranking`, (CONCAT("BTS-", `NearbyToBts3`.`nameTh`)) AS `NearbyToBts3__full_nameTh`, (CONCAT("BTS-", `NearbyToBts3`.`nameEn`)) AS `NearbyToBts3__full_nameEn` FROM `mrts` AS `Mrt` LEFT JOIN `btses` AS `NearbyToBts1` ON (`Mrt`.`nearby_bts1_id` = `NearbyToBts1`.`id`) LEFT JOIN `btses` AS `NearbyToBts2` ON (`Mrt`.`nearby_bts2_id` = `NearbyToBts2`.`id`) LEFT JOIN `btses` AS `NearbyToBts3` ON (`Mrt`.`nearby_bts3_id` = `NearbyToBts3`.`id`) WHERE `Mrt`.`id` = 13 LIMIT 1	1	1	2
20	SELECT `Mrt`.`id`, `Mrt`.`line`, `Mrt`.`station_no`, `Mrt`.`station_code`, `Mrt`.`nameTh`, `Mrt`.`nameEn`, `Mrt`.`addr`, `Mrt`.`lat`, `Mrt`.`lng`, `Mrt`.`num_rests`, `Mrt`.`num_blds`, `Mrt`.`exit1_lat`, `Mrt`.`exit1_long`, `Mrt`.`exit2_lat`, `Mrt`.`exit2_long`, `Mrt`.`exit3_lat`, `Mrt`.`exit3_long`, `Mrt`.`exit4_lat`, `Mrt`.`exit4_long`, `Mrt`.`exit5_lat`, `Mrt`.`exit5_long`, `Mrt`.`exit6_lat`, `Mrt`.`exit6_long`, `Mrt`.`created`, `Mrt`.`modified`, `Mrt`.`nearby_bts1_id`, `Mrt`.`nearby_bts2_id`, `Mrt`.`nearby_bts3_id`, `Mrt`.`nearby_mrt1_id`, `Mrt`.`nearby_mrt2_id`, `Mrt`.`nearby_mrt3_id`, `Mrt`.`popular_ranking`, (CONCAT("MRT-", `Mrt`.`nameTh`)) AS `Mrt__full_nameTh`, (CONCAT("MRT-", `Mrt`.`nameEn`)) AS `Mrt__full_nameEn`, `NearbyToMrt1`.`id`, `NearbyToMrt1`.`line`, `NearbyToMrt1`.`station_no`, `NearbyToMrt1`.`station_code`, `NearbyToMrt1`.`nameTh`, `NearbyToMrt1`.`nameEn`, `NearbyToMrt1`.`addr`, `NearbyToMrt1`.`lat`, `NearbyToMrt1`.`lng`, `NearbyToMrt1`.`num_rests`, `NearbyToMrt1`.`num_blds`, `NearbyToMrt1`.`exit1_lat`, `NearbyToMrt1`.`exit1_long`, `NearbyToMrt1`.`exit2_lat`, `NearbyToMrt1`.`exit2_long`, `NearbyToMrt1`.`exit3_lat`, `NearbyToMrt1`.`exit3_long`, `NearbyToMrt1`.`exit4_lat`, `NearbyToMrt1`.`exit4_long`, `NearbyToMrt1`.`exit5_lat`, `NearbyToMrt1`.`exit5_long`, `NearbyToMrt1`.`exit6_lat`, `NearbyToMrt1`.`exit6_long`, `NearbyToMrt1`.`created`, `NearbyToMrt1`.`modified`, `NearbyToMrt1`.`nearby_bts1_id`, `NearbyToMrt1`.`nearby_bts2_id`, `NearbyToMrt1`.`nearby_bts3_id`, `NearbyToMrt1`.`nearby_mrt1_id`, `NearbyToMrt1`.`nearby_mrt2_id`, `NearbyToMrt1`.`nearby_mrt3_id`, `NearbyToMrt1`.`popular_ranking`, (CONCAT("MRT-", `NearbyToMrt1`.`nameTh`)) AS `NearbyToMrt1__full_nameTh`, (CONCAT("MRT-", `NearbyToMrt1`.`nameEn`)) AS `NearbyToMrt1__full_nameEn`, `NearbyToMrt2`.`id`, `NearbyToMrt2`.`line`, `NearbyToMrt2`.`station_no`, `NearbyToMrt2`.`station_code`, `NearbyToMrt2`.`nameTh`, `NearbyToMrt2`.`nameEn`, `NearbyToMrt2`.`addr`, `NearbyToMrt2`.`lat`, `NearbyToMrt2`.`lng`, `NearbyToMrt2`.`num_rests`, `NearbyToMrt2`.`num_blds`, `NearbyToMrt2`.`exit1_lat`, `NearbyToMrt2`.`exit1_long`, `NearbyToMrt2`.`exit2_lat`, `NearbyToMrt2`.`exit2_long`, `NearbyToMrt2`.`exit3_lat`, `NearbyToMrt2`.`exit3_long`, `NearbyToMrt2`.`exit4_lat`, `NearbyToMrt2`.`exit4_long`, `NearbyToMrt2`.`exit5_lat`, `NearbyToMrt2`.`exit5_long`, `NearbyToMrt2`.`exit6_lat`, `NearbyToMrt2`.`exit6_long`, `NearbyToMrt2`.`created`, `NearbyToMrt2`.`modified`, `NearbyToMrt2`.`nearby_bts1_id`, `NearbyToMrt2`.`nearby_bts2_id`, `NearbyToMrt2`.`nearby_bts3_id`, `NearbyToMrt2`.`nearby_mrt1_id`, `NearbyToMrt2`.`nearby_mrt2_id`, `NearbyToMrt2`.`nearby_mrt3_id`, `NearbyToMrt2`.`popular_ranking`, (CONCAT("MRT-", `NearbyToMrt2`.`nameTh`)) AS `NearbyToMrt2__full_nameTh`, (CONCAT("MRT-", `NearbyToMrt2`.`nameEn`)) AS `NearbyToMrt2__full_nameEn`, `NearbyToMrt3`.`id`, `NearbyToMrt3`.`line`, `NearbyToMrt3`.`station_no`, `NearbyToMrt3`.`station_code`, `NearbyToMrt3`.`nameTh`, `NearbyToMrt3`.`nameEn`, `NearbyToMrt3`.`addr`, `NearbyToMrt3`.`lat`, `NearbyToMrt3`.`lng`, `NearbyToMrt3`.`num_rests`, `NearbyToMrt3`.`num_blds`, `NearbyToMrt3`.`exit1_lat`, `NearbyToMrt3`.`exit1_long`, `NearbyToMrt3`.`exit2_lat`, `NearbyToMrt3`.`exit2_long`, `NearbyToMrt3`.`exit3_lat`, `NearbyToMrt3`.`exit3_long`, `NearbyToMrt3`.`exit4_lat`, `NearbyToMrt3`.`exit4_long`, `NearbyToMrt3`.`exit5_lat`, `NearbyToMrt3`.`exit5_long`, `NearbyToMrt3`.`exit6_lat`, `NearbyToMrt3`.`exit6_long`, `NearbyToMrt3`.`created`, `NearbyToMrt3`.`modified`, `NearbyToMrt3`.`nearby_bts1_id`, `NearbyToMrt3`.`nearby_bts2_id`, `NearbyToMrt3`.`nearby_bts3_id`, `NearbyToMrt3`.`nearby_mrt1_id`, `NearbyToMrt3`.`nearby_mrt2_id`, `NearbyToMrt3`.`nearby_mrt3_id`, `NearbyToMrt3`.`popular_ranking`, (CONCAT("MRT-", `NearbyToMrt3`.`nameTh`)) AS `NearbyToMrt3__full_nameTh`, (CONCAT("MRT-", `NearbyToMrt3`.`nameEn`)) AS `NearbyToMrt3__full_nameEn` FROM `mrts` AS `Mrt` LEFT JOIN `mrts` AS `NearbyToMrt1` ON (`Mrt`.`nearby_mrt1_id` = `NearbyToMrt1`.`id`) LEFT JOIN `mrts` AS `NearbyToMrt2` ON (`Mrt`.`nearby_mrt2_id` = `NearbyToMrt2`.`id`) LEFT JOIN `mrts` AS `NearbyToMrt3` ON (`Mrt`.`nearby_mrt3_id` = `NearbyToMrt3`.`id`) WHERE `Mrt`.`id` = 13 LIMIT 1	1	1	3
21	SELECT `CuisineType`.`id`, `CuisineType`.`nameEn`, `CuisineType`.`nameTh`, `CuisineType`.`level`, `CuisineType`.`parent_id`, `CuisineType`.`popular_ranking`, `CuisineType`.`show_in_filter`, `CuisineType`.`created`, `CuisineType`.`modified`, `CuisineType`.`preferred_order` FROM `cuisine_types` AS `CuisineType` WHERE `CuisineType`.`show_in_filter` = 1 ORDER BY `CuisineType`.`level` ASC, ABS(`preferred_order`) ASC, CONVERT(`CuisineType`.`nameTh` USING tis620) ASC	74	74	0
22	SELECT `CuisineType`.`id`, `CuisineType`.`nameEn`, `CuisineType`.`nameTh`, `CuisineType`.`level`, `CuisineType`.`parent_id`, `CuisineType`.`popular_ranking`, `CuisineType`.`show_in_filter`, `CuisineType`.`created`, `CuisineType`.`modified`, `CuisineType`.`preferred_order` FROM `cuisine_types` AS `CuisineType` WHERE `CuisineType`.`popular_ranking` > 0 ORDER BY `CuisineType`.`popular_ranking` ASC LIMIT 6	6	6	0
23	SELECT `RestType`.`id`, `RestType`.`nameEn`, `RestType`.`nameTh`, `RestType`.`level`, `RestType`.`parent_id`, `RestType`.`created`, `RestType`.`modified`, `RestType`.`popular_ranking`, `RestType`.`show_in_filter`, `RestType`.`preferred_order` FROM `rest_types` AS `RestType` WHERE `RestType`.`popular_ranking` > 0 ORDER BY `RestType`.`popular_ranking` ASC LIMIT 6	5	5	0
24	SELECT `RestType`.`id`, `RestType`.`nameEn`, `RestType`.`nameTh`, `RestType`.`level`, `RestType`.`parent_id`, `RestType`.`created`, `RestType`.`modified`, `RestType`.`popular_ranking`, `RestType`.`show_in_filter`, `RestType`.`preferred_order` FROM `rest_types` AS `RestType` WHERE `RestType`.`show_in_filter` = 1 ORDER BY `RestType`.`level` ASC, ABS(`preferred_order`) ASC, CONVERT(`RestType`.`nameTh` USING tis620) ASC	20	20	0
25	SELECT `RestFeature`.`id`, `RestFeature`.`nameEn`, `RestFeature`.`nameTh`, `RestFeature`.`level`, `RestFeature`.`parent_id`, `RestFeature`.`created`, `RestFeature`.`modified`, `RestFeature`.`popular_ranking`, `RestFeature`.`preferred_order`, `RestFeature`.`show_in_filter` FROM `rest_features` AS `RestFeature` WHERE `RestFeature`.`popular_ranking` > 0 ORDER BY `RestFeature`.`popular_ranking` ASC LIMIT 6	3	3	0
26	SELECT `RestFeature`.`id`, `RestFeature`.`nameEn`, `RestFeature`.`nameTh`, `RestFeature`.`level`, `RestFeature`.`parent_id`, `RestFeature`.`created`, `RestFeature`.`modified`, `RestFeature`.`popular_ranking`, `RestFeature`.`preferred_order`, `RestFeature`.`show_in_filter` FROM `rest_features` AS `RestFeature` WHERE `RestFeature`.`show_in_filter` = 1 ORDER BY `RestFeature`.`level` ASC, ABS(`preferred_order`) ASC, CONVERT(`RestFeature`.`nameTh` USING tis620) ASC	27	27	0
27	SELECT `PriceRange`.`id`, `PriceRange`.`nameTh`, `PriceRange`.`nameEn`, `PriceRange`.`from`, `PriceRange`.`to`, `PriceRange`.`created`, `PriceRange`.`modified` FROM `price_ranges` AS `PriceRange` WHERE 1 = 1 ORDER BY `PriceRange`.`id` ASC	9	9	0

If you would like to submit feedback to us, report any bugs or problems using KinnShare website, or found any incorrect info. You can use the form below to contact us :-).

Feedback Sent!